Employee Data and Analysis
Midwest Airlines
  1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007
Traffic Indicies  
Stage Length in Miles (for SLA purposes)                691               731               707               737               770               778               780               782               802               879               879               885               944
Seats Per Departure (for SDA purposes)                79                77                80                82                86                88                91                93               100               109               106               104               104
Price Per Gallon of Fuel  $          0.54  $          0.65  $          0.62  $          0.44  $          0.50  $          0.89  $          0.82  $          0.71  $          0.88  $          1.16  $          1.71  $          1.99  $          1.84
Airborne Hours / Block Hours 86% 86% 86% 86% 84% 85% 88% 89% 88% 87% 87% 87% 88%
Outsourcing Indicies  
Maintenance $'s Outsourced 34.1% 40.7% 38.7% 42.7% 55.3% 44.5% 37.2% 28.7% 21.1% 31.2% 53.1% 55.1% 69.7%
Other Outsourcing as % of  Total Exp. (ex-Fuel) 12.0% 10.5% 8.7% 8.1% 7.2% 8.6% 8.7% 9.1% 11.0% 10.3% 10.9% 12.0% 12.8%
Transport Related Expense (000)  $           734  $           118  $           108  $             83  $           139  $           120  $           158  $           209  $           405  $           281  $           342  $           894  $      62,496
Productivity Measures (unadjusted)  
Block Hours Per Employee Per Month
Pilots & Co-Pilots (note: Includes Flight Engineers where applicable)              66.6              51.2              54.7                 -                47.9              47.7              54.5              45.5              46.6              48.2              52.2              56.2              55.3
Flight Attendants (note: Avg Crew = 1 FA per 50 seats)              34.0              32.7              36.6                 -                38.0              32.1              41.4              38.8              41.2              44.5              47.2              50.2              48.2
Maintenance              34.2              36.3              33.3                 -                23.2              15.8              16.3              16.8              24.1              22.6              47.5              53.6              52.4
Passenger, Cargo and Aircraft Handling               8.7               9.0               8.2                 -                 9.3              11.7              11.4              11.0               9.4               8.8              11.2              15.3               8.5
Other              23.2              24.1              21.9                 -                25.5              13.6              15.6              15.7              22.5              26.7              37.0              34.7              31.1
Total               3.7               3.7               3.5                 -                 3.4               3.1               3.3               3.2               3.4               3.4               4.4               5.2               4.0
ASMs Per Employee (000)
Pilots & Co-Pilots       11,625.4         8,881.4         9,505.6                 -           8,881.0         9,031.4       10,886.3         9,428.5       10,452.6       11,899.1       12,799.0       13,400.1       13,391.7
Flight Attendants         7,511.0         7,401.1         7,977.9                 -           8,227.6         6,885.7         9,133.4         8,664.0         9,241.6       10,124.1       10,858.8       11,564.5       11,186.9
Maintenance       11,929.3       12,568.0       11,574.2                 -           8,602.7         5,992.6         6,518.6         6,968.9       10,787.4       11,173.6       23,252.6       25,582.0       25,363.9
Passenger, Cargo and Aircraft Handling         3,042.0         3,117.5         2,838.4                 -           3,435.2         4,440.2         4,547.4         4,573.0         4,227.7         4,332.1         5,476.3         7,298.6         4,104.4
Other         8,111.9         8,361.1         7,598.0                 -           9,436.0         5,150.4         6,229.7         6,502.4       10,070.6       13,183.2       18,127.5       16,553.1       15,038.2
Total         1,302.8         1,266.4         1,203.6                 -           1,245.7         1,155.1         1,321.3         1,315.4         1,545.0         1,690.5         2,157.0         2,467.2         1,919.1
Employees Per Aircraft
Pilots & Co-Pilots (Crews)               4.0               5.6               5.1                 -                 5.7               5.4               4.3               5.0               4.8               5.4               5.4               5.3               5.5
Flight Attendants (Crews)               7.8               8.7               7.7                 -                 7.2               8.0               5.7               5.8               5.5               5.9               6.0               5.9               6.4
Maintenance (Inhouse)               7.7               7.9               8.4                 -                11.8              16.3              14.4              13.5               9.4              11.5               6.0               5.5               5.9
Passenger, Cargo and Aircraft Handling (Inhouse)              30.3              31.8              34.3                 -                29.5              22.0              20.7              20.5              24.0              29.7              25.4              19.4              36.2
Other (Inhouse)              11.4              11.8              12.8                 -                10.7              19.0              15.1              14.4              10.1               9.8               7.7               8.6               9.9
Total              70.7              78.2              80.9                 -                81.3              84.6              71.2              71.3              65.6              76.1              64.4              57.4              77.4
Passengers Per Employee
Pilots & Co-Pilots            9,060            6,738            7,130                 -              6,495            6,259            7,416            6,440            7,347            7,715            9,256          10,302            9,854
Flight Attendants            5,854            5,615            5,984                 -              6,017            4,772            6,222            5,918            6,496            6,564            7,853            8,891            8,232
Maintenance            9,297            9,534            8,682                 -              6,291            4,153            4,441            4,760            7,582            7,245          16,815          19,667          18,664
Passenger, Cargo and Aircraft Handling            2,371            2,365            2,129                 -              2,512            3,077            3,098            3,124            2,972            2,809            3,960            5,611            3,020
Other            6,322            6,343            5,699                 -              6,901            3,570            4,244            4,442            7,079            8,548          13,109          12,726          11,066
Total            1,015               961               903                 -                 911               801               900               899            1,086            1,096            1,560            1,897            1,412
Productivity Measures Revenue  
Passenger Revenue Per Employee (000)
Pilots & Co-Pilots  $     1,306.8  $     1,063.0  $     1,160.8  $             -    $     1,065.6  $     1,077.6  $     1,168.7  $        898.5  $        896.9  $        906.4  $     1,073.0  $     1,301.1  $     1,283.4
Flight Attendants  $        844.3  $        885.8  $        974.2  $             -    $        987.2  $        821.6  $        980.5  $        825.7  $        793.0  $        771.2  $        910.3  $     1,122.9  $     1,072.1
Maintenance  $     1,341.0  $     1,504.2  $     1,413.4  $             -    $     1,032.2  $        715.0  $        699.8  $        664.1  $        925.7  $        851.1  $     1,949.3  $     2,483.9  $     2,430.7
Passenger, Cargo and Aircraft Handling  $        341.9  $        373.1  $        346.6  $             -    $        412.2  $        529.8  $        488.2  $        435.8  $        362.8  $        330.0  $        459.1  $        708.7  $        393.3
Other  $        911.8  $     1,000.7  $        927.8  $             -    $     1,132.1  $        614.5  $        668.8  $        619.7  $        864.2  $     1,004.2  $     1,519.7  $     1,607.3  $     1,441.2
Total  $        146.4  $        151.6  $        147.0  $             -    $        149.5  $        137.8  $        141.8  $        125.4  $        132.6  $        128.8  $        180.8  $        239.6  $        183.9
Salary and Benefits  
Average Salary
Management and All Other  $      36,836  $      50,755  $      49,437  $             -    $      46,433  $      30,430  $      38,052  $      36,822  $      48,982  $      58,620  $      60,809  $      60,165  $      59,500
Pilots & Co-Pilots  $      85,197  $      72,677  $      83,059  $             -    $      74,548  $      94,373  $     125,002  $     104,213  $     115,512  $     107,474  $     101,895  $      93,052  $      88,785
Flight Attendants  $      25,032  $      25,957  $      29,436  $             -    $      30,956  $      27,805  $      38,454  $      34,681  $      32,311  $      28,869  $      31,871  $      33,080  $      30,774
Maintenance  $      33,084  $      29,060  $      35,254  $             -    $      28,831  $      26,303  $      40,428  $      44,871  $      55,650  $      46,262  $      55,026  $      46,521  $      38,807
Passenger, Cargo and Aircraft Handling  $      23,557  $      25,474  $      25,070  $             -    $      29,397  $      41,135  $      36,331  $      33,604  $      28,071  $      24,130  $      26,229  $      31,106  $      17,964
Total  $      34,111  $      37,182  $      38,870  $             -    $      39,307  $      40,157  $      48,785  $      46,493  $      49,342  $      45,264  $      47,828  $      49,303  $      37,782
Other Compensation Per Employee (All Employees)
Benefits, Pensions and Payroll Taxes
Pilots & Co-Pilots  $      12,480  $      11,511  $      14,452  $             -    $      12,620  $      17,888  $      25,024  $      20,704  $      24,688  $      24,966  $      21,988  $      16,958  $      17,769
All Others  $        3,076  $        4,166  $        3,964  $             -    $        7,180  $        7,992  $      10,496  $        9,265  $      10,047  $        9,785  $        9,791  $      13,256  $      10,006
Total  $        4,130  $        5,214  $        5,292  $             -    $        7,943  $        9,258  $      12,259  $      10,861  $      12,211  $      11,942  $      11,847  $      13,938  $      11,119
Personnel
Pilots & Co-Pilots  $        3,438  $        3,757  $        4,288  $             -    $        4,338  $        4,852  $        7,064  $        5,100  $        4,297  $        4,069  $        5,470  $        8,249  $        8,863
Flight Attendents  $        8,717  $      11,650  $      11,764  $             -    $      10,949  $        9,402  $      12,066  $      10,549  $        9,765  $        8,775  $        7,310  $        8,765  $        9,688
Payroll Taxes
Pilots & Co-Pilots  $        8,692  $        6,241  $        5,910  $             -    $        6,778  $        7,463  $        9,018  $        8,161  $        9,020  $        8,532  $        8,426  $        8,597  $        8,338
All Others  $        2,610  $        2,539  $        2,501  $             -    $        1,375  $              0  $             (0)  $            (93)  $             -    $             -    $             (0)  $              5  $             (0)
Raw Data  
Number of Months 12 12 12 12 12 12 12 12 12 12 12 12 12
Number of Days 365 366 365 365 365 366 365 365 365 366 365 365 365
P10- Employee Count Data  
Sum of General Management                23                44                67                 167                75                79                73                45                46                56                39                41
Sum of Pilots and Co-Pilots               157               225               235                 340               353               297               340               290               308               347               378               411
Sum of Other Flight Personnel                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Passenger and General Services               243               270               280                 367               463               354               370               328               362               409               438               492
Sum of Maintenance               153               159               193                 351               532               496               460               281               328               191               198               217
Sum of AC Handling 1                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Aircraft Handling               184                66                77                 212                  8                47                77                82                83                36                32                52
Sum of Aircraft Control                22                20                19                  47                44                38                40                35                36                41                43                57
Sum of Passenger Handling               372               533               663                 585               525               590               551               570               698               698               593            1,201
Sum of Cargo Handling                22                22                28                  35               141                36                33                30                29                36                26                31
Sum of Trainees and Instructors                17                22                25                  15                55                42                34                37                37                22                45                46
Sum of Stats                95                96               113                 125               110                85                90                86                74                65                86               106
Sum of Traffic Solicitors                33                30                34                  42               106                94                94                51                46                33                31                31
Sum of Other                80                91               122                 138               348               298               275               127               121               125               144               183
Sum of Transport Related                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Total            1,401            1,578            1,856            2,424            2,760            2,447            2,437            1,962            2,168            2,059            2,053            2,868
P6- Objective Grouping Operating Expense Data  
Sum of Salaries-General Management Personnel (000)  $        3,837  $        7,359  $        9,851  $      15,260  $      11,913  $        9,069  $        9,911  $        9,236  $        7,587  $      10,147  $        9,285  $        9,496  $        9,336
Sum of Salaries-Flight Personnel (000)  $      19,459  $      23,361  $      27,761  $      31,271  $      36,707  $      46,187  $      50,738  $      48,264  $      44,097  $      43,553  $      48,393  $      49,663  $      51,632
Sum of Salaries-Maintenance Labor (000)  $        5,062  $        4,621  $        6,804  $        8,071  $      10,120  $      13,993  $      20,053  $      20,641  $      15,638  $      15,174  $      10,510  $        9,211  $        8,421
Sum of Salaries-Aircraft And Traffic Handling Personnel (000)  $      14,134  $      16,329  $      19,730  $      23,099  $      25,840  $      29,535  $      25,832  $      23,556  $      20,127  $      20,414  $      21,272  $      21,587  $      24,090
Sum of Salaries-Other Personnel (000)  $        5,299  $        7,005  $        7,995  $        9,164  $      10,700  $      12,050  $      12,844  $      11,606  $        9,361  $        8,846  $        9,019  $      11,261  $      14,881
Sum of Salaries-Total (000)  $      47,790  $      58,674  $      72,142  $      86,865  $      95,279  $     110,834  $     119,377  $     113,303  $      96,809  $      98,133  $      98,478  $     101,218  $     108,359
Sum of Related Fringe Benefits-Personnel Expense (000)  $        2,658  $        3,991  $        4,301  $        4,725  $        5,493  $        6,066  $        6,369  $        5,637  $        4,449  $        4,430  $        4,888  $        6,957  $        8,409
Sum of Related Fringe Benefits-Employee Benefits And Pensions (000)  $        5,786  $        8,227  $        9,822  $      11,392  $      19,253  $      25,552  $      29,998  $      26,468  $      23,958  $      25,890  $      24,392  $      28,614  $      31,888
Sum of Related Fringe Benefits-Payroll Taxes (000)  $        4,611  $        4,839  $        5,443  $        7,570  $        5,171  $        2,635  $        2,678  $        2,579  $        2,616  $        2,628  $        2,924  $        3,258  $        3,427
Sum of Related Fringe Benefits-Total (000)  $      13,055  $      17,057  $      19,566  $      23,687  $      29,917  $      34,253  $      39,045  $      34,684  $      31,023  $      32,948  $      32,204  $      38,829  $      43,724
Sum of Total Salaries And Related Fringe Benefits (000)  $      60,845  $      75,730  $      91,708  $     110,552  $     125,197  $     145,086  $     158,423  $     147,987  $     127,832  $     131,081  $     130,682  $     140,047  $     152,083
Sum of Services Purchased-Advertising And Other Promotions (000)  $        7,414  $        6,586  $        6,495  $        6,716  $        7,500  $        9,052  $        8,872  $        9,657  $        8,924  $      10,531  $      10,985  $      11,382  $      11,129
Sum of Services Purchased-Communication (000)  $        2,070  $        2,252  $        3,045  $        3,460  $        3,704  $        3,624  $        3,800  $        3,217  $        2,982  $        3,050  $        3,988  $        4,215  $        4,389
Sum of Services Purchased-Insurance (000)  $        2,386  $        2,865  $        2,799  $        2,263  $        2,090  $        2,082  $        2,638  $        6,561  $        4,794  $        4,818  $        4,965  $        5,555  $        4,748
Sum of Services Purchased-Outside Flight Equipment Maintenance (000)  $        6,431  $        9,084  $      12,142  $      18,399  $      27,207  $      25,028  $      19,977  $      10,225  $        5,645  $      10,464  $      18,743  $      18,065  $      29,637
Sum of Services Purchased-Traffic Commissions -Passenger (000)  $      16,520  $      21,956  $      27,665  $      26,500  $      26,844  $      22,321  $      20,150  $      15,327  $        9,375  $        8,660  $      11,718  $      15,882  $      18,161
Sum of Services Purchased-Traffic Commissions-Cargo (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Sum of Services Purchased-Other Services (000)  $      20,573  $      21,303  $      20,208  $      21,536  $      22,166  $      29,080  $      30,713  $      28,866  $      30,526  $      30,694  $      36,359  $      45,276  $      61,977
Sum of Services Purchased-Total (000)  $      55,395  $      64,045  $      72,354  $      78,874  $      89,512  $      91,186  $      86,150  $      73,852  $      62,247  $      68,217  $      86,758  $     100,375  $     130,041
Sum of Transport Related Expense (000) 734.02 117.91 108.01 83.45 139.28 120.05 157.98 208.62 405.35 280.69 342.19 893.62 62496.46
Sum of Total Operating Expense (000)  $     198,960  $     239,157  $     271,893  $     298,772  $     347,045  $     414,011  $     418,617  $     375,677  $     338,189  $     381,348  $     477,156  $     568,202  $     675,513
T1 & T2- Traffic Data  
Sum of RPMs 1.17E+09 1.26E+09 1.42E+09 1.63E+09 1.97E+09 1.98E+09 1.97E+09 1.97E+09 1.99E+09 2.38E+09 3.15E+09 3.84E+09 4.23E+09
Sum of ASMs 1.83E+09 2.00E+09 2.23E+09 2.51E+09 3.02E+09 3.19E+09 3.23E+09 3.21E+09 3.03E+09 3.66E+09 4.44E+09 5.07E+09 5.50E+09
Sum of Miles 2.31E+07 2.61E+07 2.80E+07 3.08E+07 3.53E+07 3.61E+07 3.57E+07 3.46E+07 3.04E+07 3.38E+07 4.17E+07 4.89E+07 5.28E+07
Sum of Depts          33,446          35,678          39,590          41,826          45,824          46,451          45,782          44,248          37,883          38,423          47,465          55,225          55,905
Sum of Airborne Hours          54,102          59,304          66,503          72,660          82,416          85,400          85,287          82,362          71,098          77,366          94,985        111,143        119,534
Sum of Block Hours          62,757          69,177          77,174          84,380          97,736        101,027          97,183          92,878          81,145          89,094        108,783        127,416        136,459
Sum of AC Days            7,235            7,388            8,370            8,915          10,878          11,938          12,547          12,476          10,919          10,425          11,677          13,050          13,523
Sum of Gallons 5.12E+07 5.61E+07 6.32E+07 7.26E+07 8.07E+07 8.47E+07 8.23E+07 8.14E+07 6.80E+07 7.09E+07 8.34E+07 9.62E+07 1.04E+08
Sum of Passengers      1,422,405      1,515,953      1,675,633      1,896,606      2,208,196      2,209,568      2,202,652      2,189,711      2,130,669      2,376,304      3,211,717      3,894,069      4,049,994
P12- Profit and Loss Statement  
Sum of Pax Rev (000) -2.05E+05 -2.39E+05 -2.73E+05 -3.12E+05 -3.62E+05 -3.80E+05 -3.47E+05 -3.06E+05 -2.60E+05 -2.79E+05 -3.72E+05 -4.92E+05 -5.27E+05
Sum of Charter Pax (000)  $       (3,744)  $       (5,955)  $       (7,142)  $       (5,122)  $       (4,800)  $       (5,971)  $       (7,208)  $     (11,858)  $     (15,534)  $     (18,079)  $     (12,841)  $     (14,495)  $     (13,734)
Sum of Transport Related Rev (000)  $       (7,002)  $     (10,443)  $     (14,471)  $     (17,533)  $     (21,418)  $     (17,769)  $     (21,548)  $     (27,106)  $     (29,540)  $     (29,768)  $     (34,922)  $     (38,512)  $    (100,656)
Sum of Cargo Rev (000)  $       (2,995)  $       (3,272)  $       (3,574)  $       (3,895)  $       (4,231)  $       (3,852)  $       (2,916)  $       (2,689)  $       (2,521)  $       (2,517)  $       (3,430)  $       (4,339)  $       (4,388)
Sum of Total Rev (000) -2.29E+05 -2.71E+05 -3.10E+05 -3.51E+05 -4.06E+05 -4.25E+05 -3.95E+05 -3.59E+05 -3.19E+05 -3.43E+05 -4.39E+05 -5.72E+05 -6.73E+05
P52- Functional Grouping Operating Expense Data  
Sum of Pilots And Copilots (000)  $      13,376  $      16,352  $      19,519  $      21,731  $      25,346  $      33,314  $      37,125  $      35,432  $      33,498  $      33,102  $      35,202  $      34,659  $      36,491
Sum of Other Flight Personnel (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $           156  $           515  $             -  
Sum of Trainees And Instructors (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $           769  $        1,773  $        2,703
Sum of Personnel Expenses (000)  $           540  $           845  $        1,008  $        1,150  $        1,475  $        1,713  $        2,098  $        1,734  $        1,246  $        1,253  $        1,898  $        3,118  $        3,643
Sum of Employee Benefits And Pensions (000)  $        1,959  $        2,590  $        3,396  $        3,276  $        4,291  $        6,314  $        7,432  $        7,039  $        7,160  $        7,690  $        7,630  $        6,410  $        7,303
Sum of Taxes-Payroll (000)  $        1,365  $        1,404  $        1,389  $        2,128  $        2,305  $        2,635  $        2,678  $        2,775  $        2,616  $        2,628  $        2,924  $        3,250  $        3,427
Sum of Total Flight Equipment Maintenance (Memo) (000)  $      18,851  $      22,343  $      31,387  $      43,124  $      49,188  $      56,239  $      53,656  $      35,605  $      26,750  $      33,538  $      35,283  $      32,805  $      42,518
Sum of Flying Operations-Aircraft Fuels (000)  $      27,650  $      36,291  $      38,913  $      32,265  $      40,538  $      75,217  $      67,222  $      58,003  $      59,539  $      82,469  $     142,736  $     191,130  $     191,621